create procedure [dbo].[BAECartEventFunctionInsert] @CartEventID as
int,
    @FunctionCode AS varchar(32),
    @Quantity AS int,
    @Title AS varchar(128),
    @Price AS money
AS
    INSERT INTO CartEventFunction
    (CartEventID,
     FunctionCode,
     Quantity,
     Title,
     Price)
    VALUES
    (@CartEventID,
    @FunctionCode,
    @Quantity,
    @Title,
    @Price);

SELECT CAST(@@IDENTITY AS int) AS "InsertedCartEventFunction";

GO